
if exists(select name from sysobjects where name = 'sp_SinhVienCheckUpdateLyLich')
	drop proc sp_SinhVienCheckUpdateLyLich
go
/*
	Created by: Phuoc NH
	Created on: 8/1/2014 (dd/mm/yyyy)
	Description: 
	--

	File:$sql-scripts/Proc.sp_SinhVienCheckUpdateLyLich.sql
*/

create proc sp_SinhVienCheckUpdateLyLich
@MaSinhVien varchar(50)
as
begin
	select masinhvien from sinhvien where masinhvien=@MaSinhVien and ( email is null or Email ='')
end

